<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
 String no = request.getParameter("no");
 try {
	Class.forName("com.mysql.jdbc.Driver");
	Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/teacher?useUnicode=true&characterEncoding=utf-8", "root", "123456");//获得数据库连接
    PreparedStatement st=con.prepareStatement("delete from student where sno=?");
	st.setString(1, no);
	st.executeUpdate();
	st.close();
	con.close();
	request.getRequestDispatcher("showinfo.jsp").forward(request, response);
  }catch(Exception e){
	  e.printStackTrace();
  }
%>
</body>
</html>